﻿<?xml version="1.0" encoding="utf-8"?>
<AdoNetDataAccess connection="$ArticleDBConnection$" formatter="bizobjlist of eComSalesOrderItem(product)">
	<Sql>
		SELECT        
			e.id, e.idx, e.orderId, e.statusId, e.quantity, e.price, e.productId, e.description, e.calculatedProductPartId,
			p.partId as productpartId, p.checkoutWizard as productcheckoutWizard
		FROM            eComSalesOrderItems AS e LEFT OUTER JOIN
		eComProducts AS p ON e.productId = p.id
		WHERE        (e.orderId = @orderId)
		ORDER BY e.idx
	</Sql>
	<Param name="orderId" type="UniqueIdentifier"/>
</AdoNetDataAccess>
